change item order when 2 colums print out

Unfortunately this is not possible.

is there any work around for this? my entire project is stop for this an my client doesn't wan it if can not print the records in column order.

I pass months working on this!!!
ANYTHING...ANYONE... please help.

Description

Occurs before SQL query executed

Use this event if you like to modify default SQL query on the page.

Avoid editing strSQL parameter, modify strWhereClause and strOrderBy instead.
Parameters

strSQL - SQL query being to be executed.

strWhereClause - WHERE clause applied to the SQL query. Example: "active=1"

strOrderBy - ORDER BY query applied to the SQL query.Example: "ORDER BY

LastName,FirstName"

pageObject - an object of Page class representing the current page
Use this event No . Or am I missing question here?
Then change order by and change print page fields in Visual Editor?

Thank you John for your respond and help.

i think i didn't explain it well.

my problem is when i go to print out on 2 columns, the info fill out on zigzag instead per column

when i send to print on a double column setup it shows

i need to fill out per column without losing the sequence of the records.
thanks four your help.

Okay so the first 20 records show in order in column 1 and the records 21 - 40 show in order in column 2 ; is that what your are looking for.

What version of ASPrunner you use?

exactly, that's what i need.

Ver. 7.2 and trial 8.1

Okay In that case . Just go to the totals screen for print page and select grid layout button hit Columnsand enter in 2. This should show all the first 20 records in column one . And the 2nd 20 records in column 2. That's it. Let me know if this is what you are looking for .

Should be

1

2

3

4

5

6

7

8

9

10

up to 20

in first colunm
2nd column should show

11

12

13

14

15

16

17

18

19

20

One other way is to MakeColumns 3and number all the fields in your query using an alias in query 1field = Alias 1 2field = Alias 2 etc.... This will put the fields in the order you want them . Also make each field sorted the same . Either ASC or DESC and finally go to the totals screen for print and make sure the fields are in the correct order.

Here is a screeshot :

This is the only way I could get it to work.

John,

Please post an example on more detail if you can of the way you say it works with the aliases, I will give it a try.

keep in mind that my records are names, address and phone#.

Thank you for use your time and consideration to help me on this matter.

I had orignially posted screenshots here . I decided to delete it as I don't know your data structure and it wouild be inappropriate to send you on a wild goose chase. I need to see your query data table and field types in order for me to figure this out . I have made a scorecard for golf with intergers which sorted the way you want . but what I earlier stated is not entirely correct based on your data structure.
send me the fields

the query and

the format of fields

and I will sort them for you . the eay you want?

so the end result is like:>

1 ST 10 ne FullName, Notes,

1 ST 20 ne FullName, Notes,

1 ST 30 ne FullName, Notes,
2 ST 10 ne FullName, Notes,

2 ST 20 ne FullName, Notes,

2 ST 30 ne FullName, Notes,
3 ST

etc,etc

so the end result is like:

Is this what you are looking for

Notice the we concated the string to form one address . This will help in the sorting as it is one line
Now on the list page change the sort of the address . see screen shot

Notice the arrow is up . Now just select your records and click print selected. and change the grid columns in the totals area to columns and make that number 19 or whatever works for you . You can also delete some of the columns / rows particulally on the print page to get records closer together.

John,

all this you just say is exactly what i have set up on my project but as you show on your pictures works on 1 column but not on 2 or more.

here are my pictures as reference:
this is my list page

this is how is the print out normaly on 2 columns setup: ZIGZAG

i need it this way: UP-DOWN and next column UP-DOWN (this picture was edit to show the result needed)

thank you for your help

When I needed something similar to this I was using fields per column not records per column as I stated above to do a scorecard. With existing data I'm afraid there is no way to assure records that are similar addresses stay in same column. My 2nd column were fields that happened to have data that was 1-18 for golf holes. The data did not matter . I thought you could use some sort of alias to get them to sort correctly but in my testing have not been able reproduce with certain addresses on one side and certain ones on the other.